/*
 Navicat Premium Dump SQL

 Source Server         : local_mysql
 Source Server Type    : MySQL
 Source Server Version : 90100 (9.1.0)
 Source Host           : 127.0.0.1:3306
 Source Schema         : springboot_test

 Target Server Type    : MySQL
 Target Server Version : 90100 (9.1.0)
 File Encoding         : 65001

 Date: 25/12/2024 23:45:42
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `age` int NOT NULL,
  `hobbies` json DEFAULT NULL,
  `info` json DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除 【 0：未删除，1：已删除】 ',
  PRIMARY KEY (`id` DESC)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` (`id`, `name`, `age`, `hobbies`, `info`, `create_time`, `update_time`, `deleted`) VALUES (6, 'Lili', 17, '[\"piano\", \"read\", \"sport\"]', '{\"country\": \"China\", \"language\": \"Chinese\"}', '2024-12-25 05:59:27', NULL, 0);
INSERT INTO `student` (`id`, `name`, `age`, `hobbies`, `info`, `create_time`, `update_time`, `deleted`) VALUES (5, 'Lucy', 15, '[\"paint\", \"music\", \"swim\"]', '{\"country\": \"Canada\", \"language\": \"Spanish\"}', '2024-12-25 05:59:27', NULL, 0);
INSERT INTO `student` (`id`, `name`, `age`, `hobbies`, `info`, `create_time`, `update_time`, `deleted`) VALUES (4, 'Jack', 22, '[\"basketball\", \"game\", \"swim\"]', '{\"country\": \"Japan\", \"language\": \"Japanese\"}', '2024-12-25 05:59:23', NULL, 0);
INSERT INTO `student` (`id`, `name`, `age`, `hobbies`, `info`, `create_time`, `update_time`, `deleted`) VALUES (3, 'Bob', 19, '[\"program\", \"read\", \"basketball\"]', '{\"country\": \"America\", \"language\": \"English\"}', '2024-12-25 05:59:12', NULL, 0);
INSERT INTO `student` (`id`, `name`, `age`, `hobbies`, `info`, `create_time`, `update_time`, `deleted`) VALUES (2, 'John', 20, '[\"football\", \"game\"]', '{\"country\": \"Canada\", \"language\": \"English\"}', '2024-12-25 05:59:12', '2024-12-25 06:02:49', 0);
INSERT INTO `student` (`id`, `name`, `age`, `hobbies`, `info`, `create_time`, `update_time`, `deleted`) VALUES (1, 'Tom', 20, '[\"read\", \"movie\", \"swim\"]', '{\"country\": \"America\", \"language\": \"English\"}', '2024-12-25 05:58:51', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
